FO_Reports
Rhodes Group has provided standard reports, each is a record in this table.
If the SSRS report function is used to custom design reports, those reports need to be added to this table.
| Field | Type | Notes |
|---|---|---|
|
ReqOp_TID |
int |
ID field, a counter. Unique |
|
CommonName |
varchar(50) |
Short Name for report. Displays in report list. IE: Blank ABN |
|
Description |
varchar(80) |
Expanded report name. Displays in report list. IE: Blank ABN Form |
|
ReportName |
varchar(50) |
Character string, or code, referenced by software. Enter a short string with no spaces. IE: ReportBlankABN |
|
Seq |
int |
Used to sort the report list. Enter an integer to indicate where this report should be in the report list. Optional |
|
ReportType |
varchar(50) |
Identifies the report type. Enter an allowed value. Allowed values: MAIN ORDER PATIENT ANY |
|
UserPermGroup |
varchar(500) |
Permissions group(s) that can use this report. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid permgroup codes separated by pipes. Enter |ALL| if available to all permission groups. |
|
DisplayPrompts |
varchar(50) |
Determines which prompts are presented to the user when a report is invoked. Enter one or more characters from the allowed values. Allowed values: 1 = starting date/time range 2 = ending date/time range P = patient fields A = accession fields C = client code D = provider code L = location code T = container fields IE: 12PACDL |
|
Date1Default |
varchar(50) |
Default start date. Enter a valid date in MM/DD/YYYY format. Enter NOW to default to current date. |
|
Time1Default |
varchar(50) |
Default start time. Enter a valid time in HH:MM 24-hour format. Enter NOW to default to current time. |
|
Date2Default |
varchar(50) |
Default end date. Enter a valid date in MM/DD/YYYY format. Skip this entry to default to current date. |
|
Time2Default |
varchar(50) |
Default end time. Enter a valid time in HH:MM 24-hour format. Skip this entry to default to 23:59. |
|
PtFOIDDefault |
varchar(50) |
Default valid FOID. Enter a valid patient FOID or an allowed value. Skip this entry to default to no value. The patient record that the user is in when calling this report will be used for the report. Allowed values: FOID = default to current patient. This patient will always be used when this report is called. |
|
AccessionDefault |
varchar(50) |
Default accession. Enter a valid FAST Accession or an allowed value. Skip this entry to default to no value. Allowed values: ACCESSION = default to current accession in memory |
|
ClientIdDefault |
varchar(50) |
Default client ID. Enter a valid client ID or an allowed value. Skip this entry to default to no value. Allowed values: CURRENT = default to current client ID in memory |
|
PhysCodeDefault |
varchar(50) |
Default provider code. Enter a valid provider code or an allowed value. Skip this entry to default to no value. Allowed values: CURRENT = default to current provider code in memory USERDEFAULT = default to the user-level default value |
|
LocationCodeDefault |
varchar(50) |
Default location code. Enter a valid location code or an allowed value. Skip this entry to default to no value. Allowed values: CURRENT = default to current location code in memory USERDEFAULT = default to the user-level default value DEVICELOCATION = default device location user entered at logon |
|
ReportTitleDefault |
varchar(80) |
Default report title. Enter a report title to display on report. Skip this entry to use the common name as the report name. |
|
ReportQuery |
varchar(4000) |
Enter SQL select statement for report. |
|
ReportOutcome |
varchar(50) |
Future Use |
|
SSRSURL |
varchar(500) |
Enter EF = Expired Orders Instructs system to look in the FO_External_Form_Definition table for more definitions and/or a link to an external report URL in the FO_External_Form_Definition.ReportURL field. |